Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

Oracle PLSQL
1) Aggregate Functions
2) Analytical Functions
3) Char Functions
4) Constraints
5) Conversion Functions
6) Cursor
7) Data Type
8) Date Timezone
9) Hierarchical Query
10) Index
11) Insert Delete Update
12) Large Objects
13) Numeric Math Functions
14) Object Oriented Database
15) PL SQL
16) Regular Expressions
17) Report Column Page
18) Result Set
19) Select Query
20) Sequence
21) SQL Plus
22) Stored Procedure Function
23) Subquery
24) System Packages
25) System Tables Views
26) Table
27) Table Joins
28) Trigger
29) User Previliege
30) View
31) XML

Hierarchical Query
1) Browse Products with three level nested queries
2) Eliminate an entire branch of nodes from the results of a query, you add an AND clause to your CONNECT BY PRIOR clause.
3) Eliminating Nodes and Branches from a Hierarchical Query
4) Employee tree
5) Hierarchical layout
6) Hierarchical Queries
7) Including Other Conditions in a Hierarchical Query
8) LEVEL and the LPAD()
9) Level siblings
10) Lpad( ,2level-2) sys_connect_by_path(lastname, )
11) Output full path of hierarchy
12) Pseudocolumn LEVEL and an example of using the levels
13) Pseudocolumn LEVEL and an example of using the levels with an update
14) SIBLINGS sort applies order to siblings on the same level
15) Sibling layout
16) Sort by LEVEL
17) Starting at a Node Other than the Root
18) Sys_connect_by_path demo
19) Sys_connect_by_path function
20) Sys_connect_by_path function will take any column
21) Sys_connect_by_path in hierarchical query
22) Sys_connect_by_path(lastname, )
23) Traversing Upward Through the Tree
24) Use the COUNT() function and LEVEL to get the number of levels in the tree
25) Using a Subquery in a START WITH Clause
26) Using the LEVEL Pseudo-Column